//    Copyright (C) Kherty.  All rights reserved.
namespace OpenLS.Spreadsheet.Extensibility
{
    public interface IWorksheet
    {
        T ChangeType<T>(object v);

        object Info(string type_text);

        object CreateHyperlink(string location, string friendly_name);

        object GetRange(string ref_text, bool A1);

        IRange CreateRange(ICell cell1, ICell cell2);
        IWorkbook Workbook { get; }

        object Address(int row_num, int column_num, int abs_num, bool A1, string sheet_text);
        ICell GetCell(int row, int column);
        object GetPivotData(string field, IRange range, params object[] fieldAndItems);
    }
}
